package com.trkj.dao.cf;

import java.util.List;

import javax.print.attribute.standard.PageRanges;

import org.springframework.data.domain.PageRequest;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.trkj.pojo.ZszlType;
import com.trkj.vo.cf.CertificateTypeVo;
import com.trkj.vo.cf.CertificateVo;

public interface ZszlTypeDAO extends CrudRepository<ZszlType, Long> {
	@Query("select c,z from Certificate c inner join  c.zszlType z on c.certiId=z.zszlId where z.zszlName like ?1 or z.zszlId like ?1")
	List<Object[]> findAll(Pageable pageRanges,String zszlName);
	@Query("select c from ZszlType c")
	List<ZszlType> findAll12();
}	
